﻿-------------------------------------------------------------------------------
-- Provide a standard interface for popping data into the database
-------------------------------------------------------------------------------
CREATE PROCEDURE
    dbo.EntitySnapshotAdd
(
    @EntityID int 
,   @SnapshotTS datetime
,   @Reputation int
,   @LastSeen datetime
)
AS
BEGIN
    SET NOCOUNT ON;
    INSERT INTO
        dbo.EntitySnapshot
    (
        EntityID
    ,   SnapshotTS
    ,   Reputation
    ,   LastSeen
    )
    SELECT
        @EntityID
    ,   @SnapshotTS
    ,   @Reputation
    ,   @LastSeen;
END